221a503874952c755c6eadcd98d324dfbc432173,src/main/java/br/net/fabiozumbi12/RedProtect/WorldMySQLRegionManager.java,WorldMySQLRegionManager,WorldMySQLRegionManager,#World#,37
Before Change
st = null;
con = DriverManager.getConnection(this.url + this.dbname + this.reconnect, RPConfig.getString("mysql.user-name"), RPConfig.getString("mysql.user-pass"));
st = con.createStatement();
st.executeUpdate("CREATE TABLE region(name varchar(20) PRIMARY KEY NOT NULL, leaders varchar(36), admins varchar(255), members varchar(255), maxMbrX int, minMbrX int, maxMbrZ int, minMbrZ int, centerX int, centerZ int, minY int, maxY int, date varchar(10), wel varchar(64), prior int, world varchar(16), value Long not null, tppoint varchar(16))");
st.close();
st = null;
RedProtect.logger.info("Created table: 'Region'!");
st = con.createStatement();
After Change
if (!this.checkTableExists()) {
Connection con = DriverManager.getConnection(this.url + this.dbname + this.reconnect, RPConfig.getString("mysql.user-name"), RPConfig.getString("mysql.user-pass"));
st = con.prepareStatement("CREATE TABLE " + tableName + " (name varchar(20) PRIMARY KEY NOT NULL, leaders longtext, admins longtext, members longtext, maxMbrX int, minMbrX int, maxMbrZ int, minMbrZ int, centerX int, centerZ int, minY int, maxY int, date varchar(10), wel longtext, prior int, world varchar(16), value Long not null, tppoint mediumtext, rent longtext, flags longtext) CHARACTER SET utf8 COLLATE utf8_general_ci");
st.executeUpdate();
st.close();
st = null;
RedProtect.logger.info("Created table: "+tableName+"!");